Updates child organisations of the current account Example:
<next class="DatabaseUpdateStep" providerId="organisation" mode="updateOrInsert" setIntoAttribute="dealership"> <!-- use star guild code as orgid, with leading zeros - 0000133433 --> <column field="orgId" column="1" > <expr> if(formatter.isNull(value) || value == "N/A"){ return formatter.padWith("0", row[2], 10); }else{ return formatter.padWith("0", value, 10); } </expr> </column> <column field="title" column="0" /> <column field="orgType" > <value class="string">dealership</value> </column> <column field="StarClExDealerCode" column="2" /> <!-- custom field for dealership --> <column field="StarGuildCode" column="1" /> <!-- custom field for dealership --> <column field="address" column="0" /> <column field="addressLine2" column="9" /> <column field="suburb" column="10" /> <!-- custom field --> <column field="state" column="11" /> <column field="postcode" column="12" /> <column field="phone" column="13" /> <column field="country"> <value class="string">AU</value> </column> <skipIfBlankColumns> <int>0</int> <int>2</int> <int>3</int> </skipIfBlankColumns> </next>
Properties
Name | Returns | Notes | Example |
---|---|---|---|
providerId | String | ||
queryParameters | List | ||
tableFields | List |
Ask a question, or offer an answer